********************************************************************************
** 	TITLE: e4_gcso_budget.do
**
**	PROJECT: IGNITE
** 
**  PURPOSE: Appendix Figure IV: Budget of Genesee County Corrections Division
**
********************************************************************************

set sortseed 13

	import excel "$input_data/Genesee Cnty budget/costs_sheriff_corrections.xlsx", clear firstrow
	gen year=_n	
	set scheme burd4
	
	replace TotalAppropriations=TotalAppropriations-2804940 if year==5
	replace TotalAppropriations=TotalAppropriations-219113 if year==6
	replace TotalAppropriations=TotalAppropriations-11500 if year==7
	replace TotalAppropriations=TotalAppropriations/1000000
	
	
	tw connected TotalAppropriations year if year!=8, ///
		xlab(1 "2015-2016" 2 "2016-2017" 3 "2017-2018" 4 "2018-2019" 5 "2019-2020" 6 "2020-2021" 7 "2021-2022", labsize(*.7)) ///
		ylab(12(2)20, labsize(*.8)) xtitle("Fiscal year") ytitle("Total appropriations (mil. USD)")
	
	gr export "$figures/total_appropriations.pdf", replace
